/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : datax

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 12/20/2019 21:46:48 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `datax_plugin`
-- ----------------------------
DROP TABLE IF EXISTS `datax_plugin`;
CREATE TABLE `datax_plugin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_type` varchar(32) DEFAULT NULL COMMENT '插件类型，reader writer',
  `plugin_name` varchar(255) NOT NULL COMMENT '插件名，用作主键',
  `template_json` text COMMENT 'json模板',
  `comments` varchar(1000) DEFAULT NULL COMMENT '注释',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='datax插件信息';

-- ----------------------------
--  Records of `datax_plugin`
-- ----------------------------
BEGIN;
INSERT INTO `datax_plugin` VALUES ('1', 'reader', 'streamreader', '', '内存读取'), ('2', 'writer', 'streamwriter', null, '内存写'), ('3', 'reader', 'mysqlreader', null, 'mysql读取'), ('4', 'writer', 'mysqlwriter', null, 'myysql写'), ('5', 'reader', 'oraclereader', null, 'oracle读取');
COMMIT;

-- ----------------------------
--  Table structure for `datax_plugin_test`
-- ----------------------------
DROP TABLE IF EXISTS `datax_plugin_test`;
CREATE TABLE `datax_plugin_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_type` varchar(32) DEFAULT NULL COMMENT '插件类型，reader writer',
  `plugin_name` varchar(255) NOT NULL COMMENT '插件名，用作主键',
  `template_json` text COMMENT 'json模板',
  `comments` varchar(1000) DEFAULT NULL COMMENT '注释',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='datax插件信息';

-- ----------------------------
--  Records of `datax_plugin_test`
-- ----------------------------
BEGIN;
INSERT INTO `datax_plugin_test` VALUES ('2', 'writer', 'streamwriter', null, '内存写'), ('3', 'reader', 'mysqlreader', null, 'mysql读取'), ('4', 'writer', 'mysqlwriter', null, 'myysql写'), ('5', 'reader', 'oraclereader', null, 'oracle读取');
COMMIT;

-- ----------------------------
--  Table structure for `job_config`
-- ----------------------------
DROP TABLE IF EXISTS `job_config`;
CREATE TABLE `job_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '作业名',
  `job_group` varchar(255) DEFAULT NULL COMMENT '分组',
  `config_json` varchar(5000) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT '作业描述信息',
  `label` varchar(255) DEFAULT NULL COMMENT '标签（读插件、写插件)',
  `update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(1) DEFAULT '1',
  `create_by` int(11) DEFAULT NULL,
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` int(11) DEFAULT NULL,
  `config_json_param` varchar(5000) DEFAULT NULL COMMENT '执行job的spel参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='作业配置表';

-- ----------------------------
--  Records of `job_config`
-- ----------------------------
BEGIN;
INSERT INTO `job_config` VALUES ('3', null, '从datax_test库同步(appnamespace)到datax_test1库', 'test(500W)数据', '{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"name\":\"mysqlreader\",\"parameter\":{\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"Name\"],\"splitPk\":\"id\",\"connection\":[{\"table\":[\"appnamespace\"],\"jdbcUrl\":[\"jdbc:mysql://47.96.117.253:3306/datax_test\"]}]}},\"writer\":{\"name\":\"mysqlwriter\",\"parameter\":{\"writeMode\":\"insert\",\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"Name\"],\"session\":[\"set session sql_mode=\'ANSI\'\"],\"preSql\":[\"delete from appnamespace\"],\"connection\":[{\"jdbcUrl\":\"jdbc:mysql://47.96.117.253:3306/datax_test1\",\"table\":[\"appnamespace\"]}]}}}]}}', null, null, '2019-09-14 20:36:09', '1', null, '2019-06-17 22:05:31', null, null), ('8', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\"job\":{\"setting\":{\"speed\":{\"channel\":3},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"name\":\"mysqlreader\",\"parameter\":{\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"plugin_type\",\"plugin_name\",\"template_json\",\"comments\"],\"splitPk\":\"id\",\"connection\":[{\"querySql\":[\"select * from datax_plugin where id>#{#id};\"],\"jdbcUrl\":[\"jdbc:mysql://47.96.117.253:3306/datax\"]}]}},\"writer\":{\"name\":\"mysqlwriter\",\"parameter\":{\"writeMode\":\"insert\",\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"plugin_type\",\"plugin_name\",\"template_json\",\"comments\"],\"session\":[\"set session sql_mode=\'ANSI\'\"],\"preSql\":[\"delete from datax_plugin_test\"],\"connection\":[{\"jdbcUrl\":\"jdbc:mysql://47.96.117.253:3306/datax\",\"table\":[\"datax_plugin_test\"]}]}}}]}}', null, null, '2019-09-15 12:59:30', '1', null, '2019-07-05 17:19:05', null, '{\'id\':\'1\'}'), ('17', null, '123', '1321', '{}', null, null, '2019-09-14 20:36:33', '0', null, '2019-09-14 19:59:22', null, ''), ('18', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:20', '1', null, '2019-09-14 20:41:20', null, '{\'id\':\'1\'}'), ('19', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:27', '1', null, '2019-09-14 20:41:27', null, '{\'id\':\'1\'}'), ('20', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:31', '1', null, '2019-09-14 20:41:31', null, '{\'id\':\'1\'}'), ('21', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\"job\":{\"setting\":{\"speed\":{\"channel\":3},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"name\":\"mysqlreader\",\"parameter\":{\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"plugin_type\",\"plugin_name\",\"template_json\",\"comments\"],\"splitPk\":\"id\",\"connection\":[{\"querySql\":[\"select * from datax_plugin where id>#{#id};\"],\"jdbcUrl\":[\"jdbc:mysql://47.96.117.253:3306/datax\"]}]}},\"writer\":{\"name\":\"mysqlwriter\",\"parameter\":{\"writeMode\":\"insert\",\"username\":\"root\",\"password\":\"123456\",\"column\":[\"id\",\"plugin_type\",\"plugin_name\",\"template_json\",\"comments\"],\"session\":[\"set session sql_mode=\'ANSI\'\"],\"preSql\":[\"delete from datax_plugin_test\"],\"connection\":[{\"jdbcUrl\":\"jdbc:mysql://47.96.117.253:3306/datax\",\"table\":[\"datax_plugin_test\"]}]}}}]}}', null, null, '2019-09-15 12:59:36', '1', null, '2019-09-14 20:41:32', null, '{\'id\':\'1\'}'), ('22', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:33', '1', null, '2019-09-14 20:41:33', null, '{\'id\':\'1\'}'), ('23', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:35', '1', null, '2019-09-14 20:41:35', null, '{\'id\':\'1\'}'), ('24', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:36', '1', null, '2019-09-14 20:41:36', null, '{\'id\':\'1\'}'), ('25', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:37', '1', null, '2019-09-14 20:41:37', null, '{\'id\':\'1\'}'), ('26', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:39', '1', null, '2019-09-14 20:41:39', null, '{\'id\':\'1\'}'), ('27', null, '从datax_test库同步datax_plugin到datax_test1库', 'test(5条数据)', '{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"splitPk\": \"id\",\n            \"connection\": [\n              {\n                \"querySql\": [\n                  \"select * from datax_plugin where id>#{#id};\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://47.96.117.253:3306/datax\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"writeMode\": \"insert\",\n            \"username\": \"root\",\n            \"password\": \"123456\",\n            \"column\": [\n              \"id\",\n              \"plugin_type\",\n              \"plugin_name\",\n              \"template_json\",\n              \"comments\"\n            ],\n            \"session\": [\n              \"set session sql_mode=\'ANSI\'\"\n            ],\n            \"preSql\": [\n              \"delete from datax_plugin_test\"\n            ],\n            \"connection\": [\n              {\n                \"jdbcUrl\": \"jdbc:mysql://47.96.117.253:3306/datax\",\n                \"table\": [\n                  \"datax_plugin_test\"\n                ]\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}', null, null, '2019-09-14 20:41:41', '1', null, '2019-09-14 20:41:41', null, '{\'id\':\'1\'}');
COMMIT;

-- ----------------------------
--  Table structure for `job_log`
-- ----------------------------
DROP TABLE IF EXISTS `job_log`;
CREATE TABLE `job_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_id` bigint(20) NOT NULL COMMENT '抽取任务，主键ID',
  `log_file_path` varchar(255) DEFAULT NULL COMMENT '日志文件路径',
  `update_date` datetime DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `create_by` int(11) DEFAULT NULL,
  `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='抽取日志记录表';

-- ----------------------------
--  Records of `job_log`
-- ----------------------------
BEGIN;
INSERT INTO `job_log` VALUES ('70', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568383515060.log', '2019-09-13 22:05:15', '1', null, '2019-09-13 22:05:15', null), ('71', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568383717535.log', '2019-09-13 22:08:38', '1', null, '2019-09-13 22:08:38', null), ('72', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568383745651.log', '2019-09-13 22:09:06', '1', null, '2019-09-13 22:09:06', null), ('73', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568384051133.log', '2019-09-13 22:14:11', '1', null, '2019-09-13 22:14:11', null), ('74', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568384230626.log', '2019-09-13 22:17:11', '1', null, '2019-09-13 22:17:11', null), ('75', '21', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/21_1568465722751.log', '2019-09-14 20:55:23', '1', null, '2019-09-14 20:55:23', null), ('76', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568523189297.log', '2019-09-15 12:53:09', '1', null, '2019-09-15 12:53:09', null), ('77', '8', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/8_1568523234433.log', '2019-09-15 12:53:54', '1', null, '2019-09-15 12:53:54', null), ('78', '18', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/18_1568523282430.log', '2019-09-15 12:54:42', '1', null, '2019-09-15 12:54:42', null), ('79', '18', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/18_1568523315368.log', '2019-09-15 12:55:15', '1', null, '2019-09-15 12:55:15', null), ('80', '18', '/Users/sky/develop/workspace_github/skycloud-datax/data/applogs/datax-web/18_1568523531341.log', '2019-09-15 12:58:51', '1', null, '2019-09-15 12:58:51', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
